Resource for Source: C/C++/Resource for Source - C-C++.iso/codelib2/v_02_01/2n01056a

Text File | 1995-11-01 | 309 b | 13 lines

SELECT DISTINCT Machine#
FROM MachineParts Work1
WHERE NOT EXISTS
     (SELECT * FROM PickList
      WHERE NOT EXISTS
           (SELECT * FROM MachineParts Work2
             WHERE ((Work1.Machine# = Work2.Machine#)
               AND (Work2.Part# = PickList.Part#))
            )
      );